UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/BYLifIsxPYkcjs4T9GzEJHEJB1yClZkNDft0T0CrBo=' 
WHERE 
  key_id = '3cc507a5561a928890f39be8b8a95bffb26689596169549a9b04388f0c6f10a2' 
  AND (
    token = '/BYLifIsxPYkcjs4T9GzEJHEJB1yClZkNDft0T0CrBo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023