UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XWeCTnErBkiVjf8bCSwbI81tpfS07/MQB4o445zeBTM='
WHERE
key_id = '20bb97489bcd55e8c19cd033d6bacb923b7635e1aa3e95c6bbfb195155e8e60b'
AND (
token = 'XWeCTnErBkiVjf8bCSwbI81tpfS07/MQB4o445zeBTM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)