UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NxnUrt0TuDRRiTzJ1KmSf6EeTYczDDElsjaj2V+oGEA='
WHERE
key_id = 'de6f4953a13ae70ac3ce71fd435613cd6f23fb420ccda0053474ae84276ba79e'
AND (
token = 'NxnUrt0TuDRRiTzJ1KmSf6EeTYczDDElsjaj2V+oGEA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)