UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '583bptg9fdU9hZLSMQBgByO9ED1u8AayytMxM15xSK0='
WHERE
key_id = '93a77f9aa7c61bd375da30052dd025f8df9711a52e5d522e192438587de70d6f'
AND (
token = '583bptg9fdU9hZLSMQBgByO9ED1u8AayytMxM15xSK0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)