UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DzWnq9DYWDm/ihboTbyj9yxOYKcZINyb2s69Ua/7/4o='
WHERE
key_id = 'd0bc1571730fd01691b3db734e6e74b004ffba9b56880b90511eaf1ea81e6f46'
AND (
token = 'DzWnq9DYWDm/ihboTbyj9yxOYKcZINyb2s69Ua/7/4o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)