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