UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'midPPFO/9EYYYFYRqPiUb00AGHYbFIYk0BvTaqvvosI='
WHERE
key_id = 'd0a4ebfa2c8acbeb93735f7035b5c35f62772f2c22f6a4b6e1ec25623e24d356'
AND (
token = 'midPPFO/9EYYYFYRqPiUb00AGHYbFIYk0BvTaqvvosI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)