UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'PgaftKnqLi69SXudud5vsROfRbMGqajx4Qw8Pu+nbLs=' 
WHERE 
  key_id = '4bba70e71fbb990974e5c98e8db481c4301a1d99c7219e682ee2f3a07a43f10c' 
  AND (
    token = 'PgaftKnqLi69SXudud5vsROfRbMGqajx4Qw8Pu+nbLs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035