UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q3Y47N71FLUoZbS72R9IKe3nhauVnWDS5NvJ1CbSxeU='
WHERE
key_id = '9dab5f6553e1c82b29c925d9c1ffe2f4885a4fdafad1c5c7eac778aa190eb300'
AND (
token = 'q3Y47N71FLUoZbS72R9IKe3nhauVnWDS5NvJ1CbSxeU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)