UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7zaeI0/vjN6HxTn/PRtxzgMiA/MYRkoPluMfjaH/LYg='
WHERE
key_id = 'ace8bc14d7a5c54e343f9cb55fe9183159214987becec92b8f19a61a5329385d'
AND (
token = '7zaeI0/vjN6HxTn/PRtxzgMiA/MYRkoPluMfjaH/LYg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)