UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'WmkGZzsFNKLQ+2IZEjuZA3i3SOtY60A0vlg5pecm+Po=' 
WHERE 
  key_id = '82972c7f2e00c14dc7940e12269361991bf20697c4c8a74d69d02544447c3266' 
  AND (
    token = 'WmkGZzsFNKLQ+2IZEjuZA3i3SOtY60A0vlg5pecm+Po=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043