UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/5ctrxoaDtYdTP3g6JEsoB+cwioFpIWX+BrU6wc44sU='
WHERE
key_id = 'f2c9211814d9af1dd06388699e2a7aff1bfebbb643edb9014175cb27089d5beb'
AND (
token = '/5ctrxoaDtYdTP3g6JEsoB+cwioFpIWX+BrU6wc44sU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)