UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'CLJ+6FvPxr5iHZ+NGBw8yv0gc3mEvqF0fm1UUOwiO6w=' 
WHERE 
  key_id = '359f20ce29787a51b0f065cc2c70b4172f9c749d89c4b1a8d066dc3f70772151' 
  AND (
    token = 'CLJ+6FvPxr5iHZ+NGBw8yv0gc3mEvqF0fm1UUOwiO6w=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042