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