UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'niqzvAjY7vRRRAQ55WNsBKEjPjliiX4meRvSrRxk/nM='
WHERE
key_id = 'd01e3c0b69125151b63e4a5366636a9e530343a529f1d8921fcd74526558147b'
AND (
token = 'niqzvAjY7vRRRAQ55WNsBKEjPjliiX4meRvSrRxk/nM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)