UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QmCZEpQv0H4xwRzXnTEUl6ICN51bZkhmqv5R9T8CX4E='
WHERE
key_id = '96a6d0ac782d0acc44a507e735eed76e78a10a21a0947f90e9bfb6432945f699'
AND (
token = 'QmCZEpQv0H4xwRzXnTEUl6ICN51bZkhmqv5R9T8CX4E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)