UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'B9w0W6n3gw+X14wxEqAJ3qsBi4KcLBEzV6kLXDyGuHE=' 
WHERE 
  key_id = '182ad93675fbb65a596961b71e6d432a07c692682673985e9f87b487d1580f95' 
  AND (
    token = 'B9w0W6n3gw+X14wxEqAJ3qsBi4KcLBEzV6kLXDyGuHE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033