UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6NsECVQnvGK4/xTT4gJyWIRU2Zi5/sMs3IKaMq8bSiU='
WHERE
key_id = '1e4088a0e4fcbcf1ad69ad23faf41eee154addedead6c218d14d763a946d5b3b'
AND (
token = '6NsECVQnvGK4/xTT4gJyWIRU2Zi5/sMs3IKaMq8bSiU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)