UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Q2tybHQ/hiElbfm/V7AnmD/HDa0J6q+WBzs+/U28chY=' 
WHERE 
  key_id = '295dd44c4ccdb5056d2aa46b7a7b05f876c0b14671ab7bf5a632341acc6c3840' 
  AND (
    token = 'Q2tybHQ/hiElbfm/V7AnmD/HDa0J6q+WBzs+/U28chY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021