UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w2aTKXkPs3l0FR0krXtcGw00OuUzdflv6yVMcXjhfgw='
WHERE
key_id = '3eeaa7e52b5b7c9c2e2f1765e1df487ab4a9dd0dc09ad6bedc8c26c8b09a9190'
AND (
token = 'w2aTKXkPs3l0FR0krXtcGw00OuUzdflv6yVMcXjhfgw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)