UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+R7WNUNtmwc43iXmufh+bD9Ii3cWWHOngiWOp2H6GLk='
WHERE
key_id = '505164d5b8ca13f8b95394599492a14f7ab40a142002693a4d6eff1f47be965d'
AND (
token = '+R7WNUNtmwc43iXmufh+bD9Ii3cWWHOngiWOp2H6GLk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)