UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6k4cMvTKE4GHzcpMS7ek2lzjhHwDhHNrQjG/pCT1EyY='
WHERE
key_id = '8e64adcd80d17b71a5ca8ad1fa1e2def60eacb46407f33136ecfc3ff52a37569'
AND (
token = '6k4cMvTKE4GHzcpMS7ek2lzjhHwDhHNrQjG/pCT1EyY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)