UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JZ33AS4cUQAf3W/XbLQxitEB4xr7jyVoHVkp4P6J14o='
WHERE
key_id = 'ab6526de12f02b75efe696f904162328b98ad97a6742cae6c301161fb881ed2e'
AND (
token = 'JZ33AS4cUQAf3W/XbLQxitEB4xr7jyVoHVkp4P6J14o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)