UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C7gMfPBfQ30fQLQLAG10q3N+q2Ql0HbFsa0hl8ZMGQU='
WHERE
key_id = '6a146f920fb492124cf59d9bbbcf3a1c2abdf4517fd116c4c33b27d5e0ec1612'
AND (
token = 'C7gMfPBfQ30fQLQLAG10q3N+q2Ql0HbFsa0hl8ZMGQU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)