UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sCUnS0/AEd/ogJtMSxGeTyulW0Y8XfXUh0OuE5l/obU='
WHERE
key_id = '7cf0992d0fb8f2798965e0919d212eee80d7c8c27938995d10402e29e5002c9e'
AND (
token = 'sCUnS0/AEd/ogJtMSxGeTyulW0Y8XfXUh0OuE5l/obU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)