UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hW1KyJWW1WICTgMO2uQrCEljQGBzFFUvjoMfx51S+nI='
WHERE
key_id = 'c02ec91b8e3669ba7f948d2da4cdc63be5b3996e4e6b74c88a300bb2e78905c2'
AND (
token = 'hW1KyJWW1WICTgMO2uQrCEljQGBzFFUvjoMfx51S+nI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)