UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HhUvwwpaiNgdULUQ+sLrakk7DwydiEJHSscF9lRxuK4='
WHERE
key_id = '6877e6c33dea3086723dc07da0babba54ad2ee9b9b68be56260f0761038d4d8b'
AND (
token = 'HhUvwwpaiNgdULUQ+sLrakk7DwydiEJHSscF9lRxuK4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)