UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GJjcD3hfzs6xmIQgCWS6k1m1BpUYMSaJoB4OwH6bX5Q='
WHERE
key_id = 'd173b208faaef024f55fc3a96cea15b5117daae4a1e1272e06f3775a9b0a257e'
AND (
token = 'GJjcD3hfzs6xmIQgCWS6k1m1BpUYMSaJoB4OwH6bX5Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)